Basics
Introduction to SQL
- What is SQL?
- Setting up a SQL environment
- Basic SQL syntax
- Running SQL queries
Data Types
- Numeric data types
- String data types
- Date and time data types
Basic Queries
- SELECT statement
- WHERE clause
- ORDER BY clause
- LIMIT clause
Joins
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
Intermediate
Advanced Queries
- GROUP BY clause
- HAVING clause
- Subqueries
- Common Table Expressions (CTEs)
Data Modification
- INSERT statement
- UPDATE statement
- DELETE statement
- MERGE statement
Indexes
- Creating indexes
- Using indexes for optimization
- Composite indexes
- Index maintenance
Transactions
- Starting a transaction
- Committing a transaction
- Rolling back a transaction
- Transaction isolation levels
Advanced
Stored Procedures and Functions
- Creating stored procedures
- Creating functions
- Parameters and return values
- Error handling in stored procedures
Triggers
- Creating triggers
- AFTER triggers
- BEFORE triggers
- INSTEAD OF triggers
Performance Tuning
- Query optimization
- Index tuning
- Execution plans
- Monitoring and profiling
Security
- Managing users and roles
- Granting and revoking permissions
- SQL injection prevention
- Data encryption